[dbo].[EventSetupGuest]

Property	Value
Created	10:31:20 AM Tuesday, March 02, 2010
Last Modified	11:40:02 AM Monday, February 20, 2012

Name	Data Type	Max Length (Bytes)
EventCode	varchar(15)	15
GuestPageMessage	varchar(256)	256
FirstName	varchar(24)	24
FirstNameEnabled	bit	1
FirstNameRequired	bit	1
MiddleInitial	varchar(24)	24
MiddleInitialEnabled	bit	1
MiddleInitialRequired	bit	1
LastName	varchar(24)	24
LastNameEnabled	bit	1
LastNameRequired	bit	1
Address	varchar(24)	24
AddressEnabled	bit	1
AddressRequired	bit	1
City	varchar(24)	24
CityEnabled	bit	1
CityRequired	bit	1
StateProvince	varchar(24)	24
StateEnabled	bit	1
StateRequired	bit	1
PostalCode	varchar(24)	24
PostalCodeEnabled	bit	1
PostalCodeRequired	bit	1
Country	varchar(25)	25
CountryEnabled	bit	1
CountryRequired	bit	1
Prefix	varchar(25)	25
PrefixEnabled	bit	1
PrefixRequired	bit	1
Suffix	varchar(25)	25
SuffixEnabled	bit	1
SuffixRequired	bit	1
Nickname	varchar(25)	25
NicknameEnabled	bit	1
NicknameRequired	bit	1
Designation	varchar(25)	25
DesignationEnabled	bit	1
DesignationRequired	bit	1
Title	varchar(25)	25
TitleEnabled	bit	1
TitleRequired	bit	1
Company	varchar(25)	25
CompanyEnabled	bit	1
CompanyRequired	bit	1

	Name	Columns	Unique
	PK_EventSetupGuest	EventCode

Name	Columns
FK_EventSetupGuest_EventSetupGeneral	EventCode->[dbo].[EventSetupGeneral].[EventCode]

SQL Script

CREATE TABLE [dbo].[EventSetupGuest]
(
[EventCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[GuestPageMessage] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FirstName] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FirstNameEnabled] [bit] NOT NULL,
[FirstNameRequired] [bit] NOT NULL,
[MiddleInitial] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MiddleInitialEnabled] [bit] NOT NULL,
[MiddleInitialRequired] [bit] NOT NULL,
[LastName] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LastNameEnabled] [bit] NOT NULL,
[LastNameRequired] [bit] NOT NULL,
[Address] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AddressEnabled] [bit] NOT NULL,
[AddressRequired] [bit] NOT NULL,
[City] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CityEnabled] [bit] NOT NULL,
[CityRequired] [bit] NOT NULL,
[StateProvince] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[StateEnabled] [bit] NOT NULL,
[StateRequired] [bit] NOT NULL,
[PostalCode] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PostalCodeEnabled] [bit] NOT NULL,
[PostalCodeRequired] [bit] NOT NULL,
[Country] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CountryEnabled] [bit] NULL,
[CountryRequired] [bit] NULL,
[Prefix] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PrefixEnabled] [bit] NULL,
[PrefixRequired] [bit] NULL,
[Suffix] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SuffixEnabled] [bit] NULL,
[SuffixRequired] [bit] NULL,
[Nickname] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NicknameEnabled] [bit] NULL,
[NicknameRequired] [bit] NULL,
[Designation] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DesignationEnabled] [bit] NULL,
[DesignationRequired] [bit] NULL,
[Title] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TitleEnabled] [bit] NULL,
[TitleRequired] [bit] NULL,
[Company] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CompanyEnabled] [bit] NULL,
[CompanyRequired] [bit] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[EventSetupGuest] ADD CONSTRAINT [PK_EventSetupGuest] PRIMARY KEY CLUSTERED ([EventCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[EventSetupGuest] ADD CONSTRAINT [FK_EventSetupGuest_EventSetupGeneral] FOREIGN KEY ([EventCode]) REFERENCES [dbo].[EventSetupGeneral] ([EventCode])
GO